﻿/****** Object:  Table [dbo].[EatOut]  ******/

CREATE TABLE [dbo].[EatOut](
	[ID] int NOT NULL Primary Key Identity(1,1),
	[UserID] int NULL,
	[RestaurantID] int NULL,
	[Mood] int NULL,
	[MoodLevel] int NULL,
	[Weather] int NULL,
	[Temperature] int NULL,
	[TimeHour] int NULL,
	[TimeStamp] DateTime NULL,
	CHECK (Mood >= 1 AND Mood <= 4),
	CHECK (Weather >= 1 AND Weather <= 2),
	CHECK (Temperature >= 1 AND Temperature <= 4)
) ON [PRIMARY]

